package com.example.demo2.mapper;

import com.example.demo2.entity.*;
import org.apache.ibatis.annotations.*;
import org.springframework.web.bind.annotation.DeleteMapping;

import java.util.List;

@Mapper
public interface SpoMapper {
    @Select("select * from sample_orders where uID=#{uID}")
    public List<SampleOrders> findSpoByUID(@Param("uID") Integer uID);

    @Update("update sample_orders set spoNeed=#{spoNeed},spoGg=#{spoGg} where spoId=#{spoId}")
    public  int updateSpo(@Param("spoId") Integer spoId,@Param("spoNeed") String spoNeed, @Param("spoGg") String spoGg);

    @Delete("delete from sample_orders where spoId=#{spoId}")
    public  int deleteSpo(@Param("spoId") Integer spoId);
}
